<?php

class m131024_034050_create_table_static_page extends CDbMigration
{
	public function up()
	{
            $this->execute("
                CREATE TABLE IF NOT EXISTS `static_page` (
                    `id` int(11) NOT NULL AUTO_INCREMENT,
                    `content` text NOT NULL,
                    `type` tinyint(4) NOT NULL,
                    `title` varchar(200) NOT NULL,
                    PRIMARY KEY (`id`)
                ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
            ");
	}

	public function down()
	{
		echo "m131024_034050_create_table_static_page does not support migration down.\n";
		return false;
	}

	/*
	// Use safeUp/safeDown to do migration with transaction
	public function safeUp()
	{
	}

	public function safeDown()
	{
	}
	*/
}